You are here: 62. Micronet End of Year Seminar > 62.8. Appendix 1: EOY Quick Reference Procedures > End of Year Procedures - 2.7 Non-Hosted

End of Year Procedures - 2.7 Non-Hosted

 

Best Practice

Do not begin any End of Year process before you have read these instructions in full.

Prior to running an End of Month or End of Year in Micronet, it is best practice to have a complete backup of your Micronet system.

In Micronet version 2.7, a new financial year needs to be set up in the General Ledger prior to running an End of Month in June.

 

Warning

It is essential that each of these processes is monitored. Do not start a process and then leave it unsupervised. If an End of Period or End of Year process has not completed, under no circumstances should it be restarted.

Contact Service Desk immediately if you suspect that there has been, or is a problem.

Micronet General Ledger Version 2.7

To activate a new financial year in the Micronet General Ledger:

  1. In the General Ledger, select FILE | FINANCIAL YEARS.

Micronet displays the Financial Year Update screen showing the previous and current financial years set up in Micronet.

  1. To set up a new financial year, select the Add button.

Micronet displays a screen asking for the new financial year details.

  1. Enter the starting period for the new financial year.
  2. Enter a description for the new financial year in the Description field, e.g. “FY21/22”.

  1. Check that the default No of Periods in the financial year is set to 12.
  2. Set the Active field to Yes.

  1. When you are sure the details you have entered are correct, select the Accept button.

The Financial Year Update screen is redisplayed with the new financial year added.

  1. Select the Esc key to return to the General Ledger main menu.

Micronet Distribution Version 2.7

In the Creditors Ledger and Distribution, the End of Year procedure is run as an additional task, immediately after the End of Month procedure for the last month of the financial year.

You should read this document with your End of Month procedures.

Essentially, the End of Year process for Distribution runs through all of the data files and zeros the Year to Date values. For that reason, the process must be run immediately after you finish your normal End of Month procedure.

 

Technical Tip

From this point on, ALL users should be logged out of ALL applications. Terminals must not be left at the Micronet main menu; they must be logged out using START | LOGOFF at the Windows Start Menu.

Users are allowed back in to Micronet when you are confident that the EOM and EOY processes have been completed successfully.

 

 

Best Practice

Before you start the End of Month process, the following reports should be printed and/or saved as a PDF (as a minimum) and retained for audit purposes:

  • Debtors Aged Trial Balance Report
  • Monthly Sales Register
  • Inventory Valuation Report
  • Debtors Transaction Audit Report
  • Uncosted Reports by supplier for both local and imported goods.
  1. Lock the system date in MDS by selecting MAINTENANCE | CHANGE LOCAL DATE.

Micronet records the End of Year processing date in the company files. As End of Year may be run in each module at different times, it is important that the correct date is recorded, e.g. 30/6/2021.

  1. Go to the END OF PERIOD menu at the main Micronet Distribution screen. Select END OF MONTH | END OF MONTH.
  2. When End of Month is complete, it is recommended that you run the System Summary, Debtors Aged Trial Balance and Monthly Sales Register to check that the current values have been reset to 0. Investigate and correct any problems before continuing.
  1. Now log out of Distribution, log back in and check that the correct month/period appears on the main screen.
  2. In the Distribution system, select END OF PERIOD | END OF YEAR | END OF YEAR.
  3. Once the End of Year process is complete, quit out of the Distribution system and log back in again.
  4. Run the System Summary to the screen and ensure all Year to Date values are now zero.
  1. If all Year to Date values are zero, reset the system date in MDS by selecting MAINTENANCE | CHANGE LOCAL DATE then selecting Reset.

When the date is locked, it must be reset prior to posting any transactions in MDS. Micronet sets the date back to the system date. You may now let users into the system to continue trading for the new year.

Should the Year to Date values not be zero, or you are concerned about any figures displayed in your System Summary, please contact the Service Desk before continuing to trade.

Micronet Creditors Ledger Version 2.7

As with Distribution, Creditors End of Year runs through all of the data files and zeros the Year to Date values. Again it is essential that the process is run immediately after you finish your normal End of Month procedure.

 

Best Practice

Before you start the End of Month process, the following reports should be printed/and or saved as a PDF (as a minimum) and retained for audit purposes:

  • Creditors Aged Trial Balance Report
  • Creditors Aged Trial Balance with Transactions Report
  • Purchase Journal – Actual Current Report.

Note that if you are set up for multi-currency creditors, you must run these reports in the base currency set up in your Micronet system. That is, when you print the reports, make sure you set the Display Account In field to Transaction Currency on the Select Exchange Rate screen. This converts all transactions to the base currency using the transaction exchange rate.

  1. Make sure that all users are logged out of the Micronet Creditors Ledger (MCL).
  2. Lock the system date in MCL by selecting MAINTENANCE | SET LOCAL DATE then enter the end of financial year date.
  3. Run your Creditors End of Month procedure as normal.
  4. Now log out of MCL, log back in and check that the correct month/period appears on the main screen.
  5. At the main menu of MCL, select END OF PERIOD | END OF YEAR.
  6. Once the End of Year process is complete, quit out of the Creditors Ledger and log back in again.
  7. Select a regular Creditor account and run an account inquiry.

Select REPORTS | CREDITOR INQUIRY, select a creditor then select INQUIRY | ACCOUNT INQUIRY.

  1. Run a Creditor Summary on the same creditor and ensure that all Year to Date values are zero.

Select REPORTS | CREDITOR INQUIRY, select a creditor then select INQUIRY | CREDITOR SUMMARY.

  1. If all Year to Date values are zero, reset the system date in MCL by selecting MAINTENANCE | SET LOCAL DATE then selecting Reset.

You may now let users into the system to continue trading for the new financial year.

Should the Year to Date values not be zero, please contact the Service Desk before continuing to trade.

 

Technical Tip

If your site has been set up by Micronet Service Desk staff to retain access to multiple End of Year data sets, you need to run the Copy to EOY From EOM batch file to copy your End of Month data to a new EOY data area. This allows your users to select Micronet shortcuts which provide easy access to the data for each financial year – for example:

Select Start | Micronet 2.7 | Last Year | Copy To EOY From EOM and follow the prompts to copy your EOY data.

 

 

Warning

You must do this before you run the next End of Month or you will overwrite your End of Year data for June.